
'use strict'

const { Sequelize, DBPoolFile } = require('./mysqldb')

const SoundTypes = function() {
  return DBPoolFile.define(
    'sound_types',
    {
      sound_type: {
        type: Sequelize.INTEGER,
        allowNull: false,
        defaultValue: 0,
        unique: true
      },
      type_name: {
        type: Sequelize.STRING,
        allowNull: false,
        defaultValue: ''
      },
      on: {
        type: Sequelize.BOOLEAN,
        allowNull: false,
        defaultValue: true
      }
    },
    {
      tableName: 'sound_types',
      timestamps: true
    }
  )
}

const TableSoundTypes = new SoundTypes()

module.exports = {
  TableSoundTypes
}
